{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Hoja6"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Hoja6","index":0,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,0,18,1],[7,4,7,5],[8,4,8,5],[9,2,9,7],[10,2,10,3],[10,4,10,5],[10,6,10,7],[0,0,1,4],[3,0,4,1],[3,4,4,5],[3,6,3,7],[5,0,6,1],[5,4,6,5],[5,6,6,6],[5,7,6,7]]}
["Simulador Presupuestario"]
[]
["Presupuesto Nº"]
["Ingresos Previstos (Valor del Presupuesto)",null,null,null,"133.844,00",null,"Significación"]
[null,null,null,null,null,null,"Calculada","Estandar"]
["Costes Variables Estimados (Materia prima, tinta, etc.)",null,null,null,"73.444,00",null,{"$f":"E6/E4","v":0.54872837034159172},0.21290127114216581]
[]
["Costes No Operativos Variables",null,2.9455239366261061E-2,null,{"$f":"C8*E4","v":3942.4070577378452}]
["Tot. Costes Fijos o Estructurales",null,{"$f":"B18","v":254},{"$f":"E9/C9","v":49.613290607887521},{"$f":"C18","v":12601.775814403431},null,{"$f":"D18","v":9.4152713714499195E-2},0.77604085517466825]
["Horas Estimadas de Trabajo",null,"Nivel de Actividad"]
[null,null," [ 100% / 76% ]",null," [ 75% / 51% ]",null," [ - 50% ]"]
["Dptos. Operativos","Nº de Hras","Unitario","Total","Unitario","Total","Unitario","Total"]
["Taller I","100,00",47.745497593212036,{"$f":"IF(C13=\" \",\" \",C13*B13)","v":4774.549759321204},59.262768377253806,{"$f":"IF(E13=\" \",\" \",E13*B13)","v":5926.2768377253806},82.297309945337361,{"$f":"IF(G13=\" \",\" \",G13*B13)","v":8229.7309945337365}]
["Taller II","100,00",59.372260550822261,{"$f":"IF(C14=\" \",\" \",C14*B14)","v":5937.2260550822266},71.802156132355847,{"$f":"IF(E14=\" \",\" \",E14*B14)","v":7180.2156132355849},96.661947295423019,{"$f":"IF(G14=\" \",\" \",G14*B14)","v":9666.1947295423015}]
["Taller III","54,00",35,{"$f":"IF(C15=\" \",\" \",C15*B15)","v":1890},45,{"$f":"IF(E15=\" \",\" \",E15*B15)","v":2430},55,{"$f":"IF(G15=\" \",\" \",G15*B15)","v":2970}]
[null,null,{"$f":"IFERROR(VLOOKUP(#REF!,[1]Indicadores!$AF$37:$AP$40,9),\" \")","v":" "},{"$f":"IF(C16=\" \",\" \",C16*B16)","v":" "},{"$f":"IFERROR(VLOOKUP(#REF!,[1]Indicadores!$AF$37:$AP$40,10),\" \")","v":" "},{"$f":"IF(E16=\" \",\" \",E16*B16)","v":" "},{"$f":"IFERROR(VLOOKUP(#REF!,[1]Indicadores!$AF$37:$AP$40,11),\" \")","v":" "},{"$f":"IF(G16=\" \",\" \",G16*B16)","v":" "}]
[null,null,{"$f":"IFERROR(VLOOKUP(#REF!,[1]Indicadores!$AF$37:$AP$40,9),\" \")","v":" "},{"$f":"IF(C17=\" \",\" \",C17*B17)","v":" "},{"$f":"IFERROR(VLOOKUP(#REF!,[1]Indicadores!$AF$37:$AP$40,10),\" \")","v":" "},{"$f":"IF(E17=\" \",\" \",E17*B17)","v":" "},{"$f":"IFERROR(VLOOKUP(#REF!,[1]Indicadores!$AF$37:$AP$40,11),\" \")","v":" "},{"$f":"IF(G17=\" \",\" \",G17*B17)","v":" "}]
["Subtotal",{"$f":"B13+B14+B15","v":254},{"$f":"SUM(D13:D17)","v":12601.775814403431},{"$f":"C18/E4","v":9.4152713714499195E-2},{"$f":"SUM(F13:F17)","v":15536.492450960966},{"$f":"E18/E4","v":0.11607911038941579},{"$f":"SUM(H13:H17)","v":20865.925724076038},{"$f":"G18/E4","v":0.15589735605687247}]
[" = Resultado previsto",null,{"$f":"$E$4-$E$6-$E$8-C18","v":43855.817127858725},{"$f":"C19/E4","v":0.32766367657764806},{"$f":"$E$4-$E$6-$E$8-E18","v":40921.100491301186},{"$f":"E19/E4","v":0.30573727990273142},{"$f":"$E$4-$E$6-$E$8-G18","v":35591.667218186121},{"$f":"G19/E4","v":0.2659190342352748}]